orcli import tsv

import tab-separated values (TSV)

Usage

Arguments
Path to one or more files or URLs. When FILE is -, read standard input.
(repeatable)
Options
store blank cells as empty strings instead of nulls
set column names (comma separated) hint: add --ignoreLines 1 to overwrite existing header row
conflicts: --headerLines
set character encoding
attempt to parse cell text into numbers
parse x line(s) as column headers
conflicts: --columnNames
ignore first x line(s) at beginning of file
do not use any quote character to enclose cells containing column separators
add column with file source
add column with archive file name
load at most x row(s) of data
quote character to enclose cells containing column separators
do not store blank rows
discard initial x row(s) of data
trim leading & trailing whitespace from strings
set a name for the OpenRefine project
set project tags (comma separated)
suppress log output, print errors only
Parent Environment Variables
URL to OpenRefine server

Examples

orcli import tsv "file"
orcli import tsv "file1" "file2"
head -n 100 "file" | orcli import tsv
orcli import tsv "https://example.com/file.tsv"
orcli import tsv "file" \
  --separator ";" \
  --columnNames "foo,bar,baz" \
  --ignoreLines 1 \
  --encoding "ISO-8859-1" \
  --limit 100 \
  --trimStrings \
  --projectName "duplicates" \
  --projectTags "test,urgent"